|
400
|
How can I display the column using currency format and enlarge the font for certain values
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
;
super();
var_Column = COM::createFromVariant(excombobox1.Columns().Add("Currency")); com_Column = var_Column;
com_Column.Def(17/*exCellCaptionFormat*/,COMVariant::createFromInt(1));
com_Column.FormatColumn("len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("1.23");
com_Items.AddItem("2.34");
com_Items.AddItem("9.94");
com_Items.AddItem("11.94");
com_Items.AddItem("1000");
}
|
|
399
|
How can I get the number of occurrences of a specified string in the cell
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
int h;
;
super();
excombobox1.Columns().Add("");
var_Column = COM::createFromVariant(excombobox1.Columns().Add("occurrences")); com_Column = var_Column;
com_Column.ComputedField("lower(%0) count 'o'");
com_Column.FormatColumn("'contains ' + value + ' of \\'o\\' chars'");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root");
com_Items.InsertItem(h,,"Child 1 oooof the root");
com_Items.InsertItem(h,,"Child 2");
com_Items.InsertItem(h,,"Child 3");
com_Items.ExpandItem(h,true);
}
|
|
398
|
How can I display dates in my format
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
;
super();
var_Column = COM::createFromVariant(excombobox1.Columns().Add("Date")); com_Column = var_Column;
com_Column.Def(17/*exCellCaptionFormat*/,COMVariant::createFromInt(1));
com_Column.FormatColumn("'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromDate(str2Date("1/21/2001",213)));
com_Items.AddItem(COMVariant::createFromDate(str2Date("2/22/2002",213)));
com_Items.AddItem(COMVariant::createFromDate(str2Date("3/13/2003",213)));
com_Items.AddItem(COMVariant::createFromDate(str2Date("4/24/2004",213)));
}
|
|
397
|
How can I display dates in short format
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
COM::createFromVariant(excombobox1.Columns().Add("Date")).FormatColumn("shortdate(value)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromDate(str2Date("1/1/2001",213)));
com_Items.AddItem(COMVariant::createFromDate(str2Date("2/2/2002",213)));
com_Items.AddItem(COMVariant::createFromDate(str2Date("3/3/2003",213)));
com_Items.AddItem(COMVariant::createFromDate(str2Date("4/4/2004",213)));
}
|
|
396
|
How can I display dates in long format
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
COM::createFromVariant(excombobox1.Columns().Add("Date")).FormatColumn("longdate(value)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromDate(str2Date("1/1/2001",213)));
com_Items.AddItem(COMVariant::createFromDate(str2Date("2/2/2002",213)));
com_Items.AddItem(COMVariant::createFromDate(str2Date("3/3/2003",213)));
com_Items.AddItem(COMVariant::createFromDate(str2Date("4/4/2004",213)));
}
|
|
395
|
How can I display only the right part of the cell
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
int h;
;
super();
excombobox1.Columns().Add("");
var_Column = COM::createFromVariant(excombobox1.Columns().Add("Right")); com_Column = var_Column;
com_Column.ComputedField("%0 right 2");
com_Column.FormatColumn("'\"' + value + '\"'");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root");
com_Items.InsertItem(h,,"Child 1");
com_Items.InsertItem(h,,"Child 2");
com_Items.InsertItem(h,,"SChild 3");
com_Items.ExpandItem(h,true);
}
|
|
394
|
How can I display only the left part of the cell
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.Columns().Add("");
COM::createFromVariant(excombobox1.Columns().Add("Left")).ComputedField("%0 left 2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root");
com_Items.InsertItem(h,,"Child 1");
com_Items.InsertItem(h,,"Child 2");
com_Items.InsertItem(h,,"SChild 3");
com_Items.ExpandItem(h,true);
}
|
|
393
|
How can I display true or false instead 0 and -1
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
COM::createFromVariant(excombobox1.Columns().Add("Boolean")).FormatColumn("value != 0 ? 'true' : 'false'");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromBoolean(true));
com_Items.AddItem(COMVariant::createFromBoolean(false));
com_Items.AddItem(COMVariant::createFromBoolean(true));
com_Items.AddItem(COMVariant::createFromInt(0));
com_Items.AddItem(COMVariant::createFromInt(1));
}
|
|
392
|
How can I display icons or images instead numbers
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
str var_s;
;
super();
var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql";
var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0";
var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN";
var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=";
excombobox1.Images(COMVariant::createFromStr(var_s));
var_Column = COM::createFromVariant(excombobox1.Columns().Add("Icons")); com_Column = var_Column;
com_Column.Def(17/*exCellCaptionFormat*/,COMVariant::createFromInt(1));
com_Column.FormatColumn("'The cell displays the icon <img>'+value+'</img> instead ' + value");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromInt(1));
com_Items.AddItem(COMVariant::createFromInt(2));
com_Items.AddItem(COMVariant::createFromInt(3));
}
|
|
391
|
How can I display the column using currency
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
COM::createFromVariant(excombobox1.Columns().Add("Currency")).FormatColumn("currency(dbl(value))");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("1.23");
com_Items.AddItem("2.34");
com_Items.AddItem("0");
com_Items.AddItem(COMVariant::createFromInt(5));
com_Items.AddItem("10000.99");
}
|
|
390
|
How can I display the currency only for not empty cells
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Number");
COM::createFromVariant(excombobox1.Columns().Add("Currency")).ComputedField("len(%0) ? currency(dbl(%0)) : ''");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("1.23");
com_Items.AddItem("2.34");
com_Items.AddItem("0");
com_Items.ItemBackColor(com_Items.AddItem(),WinApi::RGB2int(255,128,128));
com_Items.AddItem("10000.99");
}
|
|
389
|
Is there a function to display the number of days between two date including the number of hours
public void init()
{
COM com_Items;
anytype var_Items;
int h;
str var_s;
;
super();
COM::createFromVariant(excombobox1.Columns().Add("Start")).Width(32);
excombobox1.Columns().Add("End");
var_s = "2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : '";
var_s = var_s + "') + =:3 + ' hour(s)' : '' )";
COM::createFromVariant(excombobox1.Columns().Add("Duration")).ComputedField(var_s);
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem(COMVariant::createFromDate(str2Date("1/11/2001",213)));
com_Items.CellCaption(h,COMVariant::createFromInt(1),COMVariant::createFromDate(str2Date("1/14/2001",213)));
h = com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 12:00:00",213)));
com_Items.CellCaption(h,COMVariant::createFromInt(1),COMVariant::createFromUtcDateTime(str2Datetime("3/14/2002 13:00:00",213)));
h = com_Items.AddItem(COMVariant::createFromDate(str2Date("3/13/2003",213)));
com_Items.CellCaption(h,COMVariant::createFromInt(1),COMVariant::createFromUtcDateTime(str2Datetime("4/11/2003 11:00:00",213)));
}
|
|
388
|
Is there a function to display the number of days between two date including the number of hours
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.Columns().Add("Start");
excombobox1.Columns().Add("End");
COM::createFromVariant(excombobox1.Columns().Add("Duration")).ComputedField("\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem(COMVariant::createFromDate(str2Date("1/11/2001",213)));
com_Items.CellCaption(h,COMVariant::createFromInt(1),COMVariant::createFromUtcDateTime(str2Datetime("1/14/2001 23:00:00",213)));
h = com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 12:00:00",213)));
com_Items.CellCaption(h,COMVariant::createFromInt(1),COMVariant::createFromUtcDateTime(str2Datetime("3/14/2002 13:00:00",213)));
h = com_Items.AddItem(COMVariant::createFromDate(str2Date("3/13/2003",213)));
com_Items.CellCaption(h,COMVariant::createFromInt(1),COMVariant::createFromUtcDateTime(str2Datetime("4/11/2003 11:00:00",213)));
}
|
|
387
|
How can I display the number of days between two dates
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.Columns().Add("Start");
excombobox1.Columns().Add("End");
COM::createFromVariant(excombobox1.Columns().Add("Duration")).ComputedField("(date(%1)-date(%0)) + ' days'");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem(COMVariant::createFromDate(str2Date("1/11/2001",213)));
com_Items.CellCaption(h,COMVariant::createFromInt(1),COMVariant::createFromDate(str2Date("1/14/2001",213)));
h = com_Items.AddItem(COMVariant::createFromDate(str2Date("2/22/2002",213)));
com_Items.CellCaption(h,COMVariant::createFromInt(1),COMVariant::createFromDate(str2Date("3/14/2002",213)));
h = com_Items.AddItem(COMVariant::createFromDate(str2Date("3/13/2003",213)));
com_Items.CellCaption(h,COMVariant::createFromInt(1),COMVariant::createFromDate(str2Date("4/11/2003",213)));
}
|
|
386
|
How can I get second part of the date
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("Second")).ComputedField("sec(date(%0))");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:10:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:01:22",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:23:01",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:11:59",213)));
}
|
|
385
|
How can I get minute part of the date
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("Minute")).ComputedField("min(date(%0))");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:10:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:01:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:23:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:11:00",213)));
}
|
|
384
|
How can I check the hour part only so I know it was afternoon
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
;
super();
var_ConditionalFormat = COM::createFromObject(excombobox1.ConditionalFormats()).Add("hour(%0)>=12"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.Bold(true);
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("Hour")).ComputedField("hour(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:00:00",213)));
}
|
|
383
|
What about a function to get the day in the week, or days since Sunday
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("WeekDay")).ComputedField("weekday(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:00:00",213)));
}
|
|
382
|
Is there any function to get the day of the year or number of days since January 1st
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("Day since January 1st")).ComputedField("yearday(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:00:00",213)));
}
|
|
381
|
How can I display only the day of the date
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("Day")).ComputedField("day(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:00:00",213)));
}
|
|
380
|
How can I display only the month of the date
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("Month")).ComputedField("month(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/2/2002 11:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/3/2003 12:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/4/2004 13:00:00",213)));
}
|
|
379
|
How can I get only the year part from a date expression
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("Year")).ComputedField("year(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/2/2002 11:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/3/2003 12:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/4/2004 13:00:00",213)));
}
|
|
378
|
Can I convert the expression to date
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Number");
COM::createFromVariant(excombobox1.Columns().Add("Date")).ComputedField("date(dbl(%0))");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("-1.98");
com_Items.AddItem("30000.99");
com_Items.AddItem("3561.23");
com_Items.AddItem("1232.34");
}
|
|
377
|
Can I convert the expression to a number, double or float
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Number");
COM::createFromVariant(excombobox1.Columns().Add("Number + 2")).ComputedField("dbl(%0)+2");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("-1.98");
com_Items.AddItem("0.99");
com_Items.AddItem("1.23");
com_Items.AddItem("2.34");
}
|
|
376
|
How can I display dates in long format
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("LongFormat")).ComputedField("longdate(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/2/2002 11:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/3/2003 12:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/4/2004 13:00:00",213)));
}
|
|
375
|
How can I display dates in short format
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("ShortFormat")).ComputedField("shortdate(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/2/2002 11:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/3/2003 12:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/4/2004 13:00:00",213)));
}
|
|
374
|
How can I display the time only of a date expression
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Date");
COM::createFromVariant(excombobox1.Columns().Add("Time")).ComputedField("'time is:' + time(date(%0))");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("2/2/2002 11:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("3/3/2003 12:00:00",213)));
com_Items.AddItem(COMVariant::createFromUtcDateTime(str2Datetime("4/4/2004 13:00:00",213)));
}
|
|
373
|
Is there any function to display currencies, or money formatted as in the control panel
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Number");
COM::createFromVariant(excombobox1.Columns().Add("Currency")).ComputedField("currency(dbl(%0))");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("1.23");
com_Items.AddItem("2.34");
com_Items.AddItem("10000.99");
}
|
|
372
|
How can I convert the expression to a string so I can look into the date string expression for month's name
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Number");
COM::createFromVariant(excombobox1.Columns().Add("Str")).ComputedField("str(%0) + ' AA'");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("-1.98");
com_Items.AddItem("0.99");
com_Items.AddItem("1.23");
com_Items.AddItem("2.34");
}
|
|
371
|
Can I display the absolute value or positive part of the number
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Number");
COM::createFromVariant(excombobox1.Columns().Add("Abs")).ComputedField("abs(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("-1.98");
com_Items.AddItem("0.99");
com_Items.AddItem("1.23");
com_Items.AddItem("2.34");
}
|
|
370
|
Is there any function to get largest number with no fraction part that is not greater than the value
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Number");
COM::createFromVariant(excombobox1.Columns().Add("Floor")).ComputedField("floor(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("-1.98");
com_Items.AddItem("0.99");
com_Items.AddItem("1.23");
com_Items.AddItem("2.34");
}
|
|
369
|
Is there any function to round the values base on the .5 value
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Number");
COM::createFromVariant(excombobox1.Columns().Add("Round")).ComputedField("round(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("-1.98");
com_Items.AddItem("0.99");
com_Items.AddItem("1.23");
com_Items.AddItem("2.34");
}
|
|
368
|
How can I get or display the integer part of the cell
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Number");
COM::createFromVariant(excombobox1.Columns().Add("Int")).ComputedField("int(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("-1.98");
com_Items.AddItem("0.99");
com_Items.AddItem("1.23");
com_Items.AddItem("2.34");
}
|
|
367
|
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
COM::createFromVariant(excombobox1.Columns().Add("")).ComputedField("proper(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("root");
com_Items.InsertItem(h,,"child child");
com_Items.InsertItem(h,,"child child");
com_Items.InsertItem(h,,"child child");
com_Items.ExpandItem(h,true);
}
|
|
366
|
Is there any option to display cells in uppercase
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
COM::createFromVariant(excombobox1.Columns().Add("")).ComputedField("upper(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root");
com_Items.InsertItem(h,,"Child 1");
com_Items.InsertItem(h,,"Child 2");
com_Items.InsertItem(h,,"Chld 3");
com_Items.ExpandItem(h,true);
}
|
|
365
|
Is there any option to display cells in lowercase
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
COM::createFromVariant(excombobox1.Columns().Add("")).ComputedField("lower(%0)");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root");
com_Items.InsertItem(h,,"Child 1");
com_Items.InsertItem(h,,"Child 2");
com_Items.InsertItem(h,,"Chld 3");
com_Items.ExpandItem(h,true);
}
|
|
364
|
How can I mark the cells that has a specified type, ie strings only
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
int h;
;
super();
var_ConditionalFormat = COM::createFromObject(excombobox1.ConditionalFormats()).Add("type(%0) = 8"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.ForeColor(WinApi::RGB2int(255,0,0));
excombobox1.Columns().Add("");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root");
com_Items.InsertItem(h,,"Child 1");
com_Items.InsertItem(h,,COMVariant::createFromInt(2));
com_Items.InsertItem(h,,"Chld 3");
com_Items.ExpandItem(h,true);
}
|
|
363
|
How can I bold the items that contains data or those who displays empty strings
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
int h,hC;
;
super();
var_ConditionalFormat = COM::createFromObject(excombobox1.ConditionalFormats()).Add("not len(%1)=0"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.Bold(true);
excombobox1.Columns().Add("C1");
excombobox1.Columns().Add("C2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root");
com_Items.InsertItem(h,,"Child 1");
hC = com_Items.InsertItem(h,,"Child 2");
com_Items.CellCaption(hC,COMVariant::createFromInt(1),"1");
com_Items.InsertItem(h,,"Child 3");
com_Items.ExpandItem(h,true);
}
|
|
362
|
Can I change the background color for items or cells that contains a specified string
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
int h;
;
super();
var_ConditionalFormat = COM::createFromObject(excombobox1.ConditionalFormats()).Add("%0 contains 'hi'"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.BackColor(WinApi::RGB2int(255,0,0));
excombobox1.Columns().Add("");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root");
com_Items.InsertItem(h,,"Child 1");
com_Items.InsertItem(h,,"Child 2");
com_Items.InsertItem(h,,"Chld 3");
com_Items.ExpandItem(h,true);
}
|
|
361
|
Is there any option to change the fore color for cells or items that ends with a specified string
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
int h;
;
super();
var_ConditionalFormat = COM::createFromObject(excombobox1.ConditionalFormats()).Add("%0 endwith '22'"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.ForeColor(WinApi::RGB2int(255,0,0));
excombobox1.Columns().Add("");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root");
com_Items.InsertItem(h,,"Child 1");
com_Items.InsertItem(h,,"Child 1.22");
com_Items.InsertItem(h,,"Child 2.22");
com_Items.ExpandItem(h,true);
}
|
|
360
|
How can I highlight the cells or items that starts with a specified string
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
int h;
;
super();
var_ConditionalFormat = COM::createFromObject(excombobox1.ConditionalFormats()).Add("%0 startwith 'C'"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.Underline(true);
excombobox1.Columns().Add("");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root");
com_Items.InsertItem(h,,"Child 1");
com_Items.InsertItem(h,,"Child 2");
com_Items.InsertItem(h,,"SChild 3");
com_Items.ExpandItem(h,true);
}
|
|
359
|
How can I change the background color or the visual appearance using ebn for a particular column
public void init()
{
COM com_Columns;
anytype var_Columns;
;
super();
excombobox1.VisualAppearance().Add(1,"c:\\exontrol\\images\\normal.ebn");
var_Columns = excombobox1.Columns(); com_Columns = var_Columns;
com_Columns.Add("Column 1");
COM::createFromVariant(com_Columns.Add("Column 2")).Def(7/*exHeaderBackColor*/,COMVariant::createFromInt(16777216));
COM::createFromVariant(com_Columns.Add("Column 3")).Def(7/*exHeaderBackColor*/,COMVariant::createFromInt(16777471));
com_Columns.Add("Column 4");
}
|
|
358
|
How can I change the background color for a particular column
public void init()
{
COM com_Columns;
anytype var_Columns;
;
super();
var_Columns = excombobox1.Columns(); com_Columns = var_Columns;
com_Columns.Add("Column 1");
COM::createFromVariant(com_Columns.Add("Column 2")).Def(7/*exHeaderBackColor*/,COMVariant::createFromInt(8439039));
com_Columns.Add("Column 3");
}
|
|
357
|
Does your control support prompt feature
public void init()
{
str var_s;
;
super();
var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql";
var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0";
var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN";
var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=";
excombobox1.Images(COMVariant::createFromStr(var_s));
excombobox1.AutoComplete(false);
COM::createFromVariant(excombobox1.Columns().Add("Column 1")).Prompt("<img>1</img><i><fgcolor=808080>type to search</fgcolor></i>");
excombobox1.Items().AddItem(COMVariant::createFromInt(0));
excombobox1.Items().AddItem(COMVariant::createFromInt(1));
excombobox1.Items().AddItem(COMVariant::createFromInt(2));
}
|
|
356
|
How can I display the column's header using multiple lines
public void init()
{
;
super();
excombobox1.HeaderHeight(128);
excombobox1.HeaderSingleLine(false);
COM::createFromVariant(excombobox1.Columns().Add("This is just a column that should break the header.")).Width(32);
excombobox1.Columns().Add("This is just another column that should break the header.");
}
|
|
355
|
How can I sort the value gets listed in the drop down filter window
public void init()
{
COM com_Column,com_Column1,com_Items;
anytype var_Column,var_Column1,var_Items;
int h;
;
super();
excombobox1.LinesAtRoot(-1/*exLinesAtRoot*/);
excombobox1.MarkSearchColumn(false);
excombobox1.Description(0/*exFilterBarAll*/,"");
excombobox1.Description(1/*exFilterBarBlanks*/,"");
excombobox1.Description(2/*exFilterBarNonBlanks*/,"");
var_Column = COM::createFromVariant(excombobox1.Columns().Add("P1")); com_Column = var_Column;
com_Column.DisplayFilterButton(true);
com_Column.DisplayFilterPattern(false);
com_Column.FilterList(16/*exSortItemsDesc*/);
var_Column1 = COM::createFromVariant(excombobox1.Columns().Add("P2")); com_Column1 = var_Column1;
com_Column1.DisplayFilterButton(true);
com_Column1.DisplayFilterPattern(false);
com_Column1.FilterList(32/*exSortItemsAsc*/);
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Z3");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"C");
com_Items.CellCaption(com_Items.InsertItem(h,,"Z1"),COMVariant::createFromInt(1),"B");
com_Items.CellCaption(com_Items.InsertItem(h,,"Z2"),COMVariant::createFromInt(1),"A");
com_Items.ExpandItem(h,true);
}
|
|
354
|
Is there any property to disable the popup/context menu being shown when the user does a right click in the control's label area
public void init()
{
;
super();
COM::createFromVariant(excombobox1.Columns().Add("Default")).AllowEditContextMenu(false);
excombobox1.Items().AddItem(COMVariant::createFromInt(0));
excombobox1.Items().AddItem(COMVariant::createFromInt(1));
excombobox1.Items().AddItem(COMVariant::createFromInt(2));
}
|
|
353
|
How can I align the text/caption on the scroll bar
public void init()
{
;
super();
excombobox1.ScrollPartCaption(1/*exHScroll*/,512/*exLowerBackPart*/,"left");
excombobox1.ScrollPartCaptionAlignment(1/*exHScroll*/,512/*exLowerBackPart*/,0/*LeftAlignment*/);
excombobox1.ScrollPartCaption(1/*exHScroll*/,128/*exUpperBackPart*/,"right");
excombobox1.ScrollPartCaptionAlignment(1/*exHScroll*/,128/*exUpperBackPart*/,2/*RightAlignment*/);
excombobox1.ColumnAutoResize(false);
excombobox1.Columns().Add(1);
excombobox1.Columns().Add(2);
excombobox1.Columns().Add(3);
excombobox1.Columns().Add(4);
excombobox1.Columns().Add(5);
excombobox1.Columns().Add(6);
}
|
|
352
|
Does you control support RTL languages or if there is a property RightToLeft
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
;
super();
excombobox1.RightToLeft(true);
excombobox1.ItemsAllowSizing(-1/*exResizeItem*/);
excombobox1.DrawGridLines(1/*exHLines*/);
excombobox1.LinesAtRoot(-1/*exLinesAtRoot*/);
excombobox1.ScrollBySingleLine(true);
excombobox1.DefaultItemHeight(64);
var_Column = COM::createFromVariant(excombobox1.Columns().Add("Column")); com_Column = var_Column;
com_Column.Alignment(2/*RightAlignment*/);
com_Column.HeaderAlignment(2/*RightAlignment*/);
com_Column.EditAlignment(2/*RightAlignment*/);
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 1");
com_Items.ItemHeight(com_Items.InsertItem(com_Items.AddItem("Parent"),,"Item 2"),48);
com_Items.AddItem("Item 3");
com_Items.ExpandItem(com_Items.ItemByIndex(1),true);
}
|
|
351
|
How do I enable resizing all the items at runtime
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.ItemsAllowSizing(1/*exResizeAllItems*/);
excombobox1.DrawGridLines(1/*exHLines*/);
excombobox1.Columns().Add("Column");
excombobox1.Items().AddItem("Item 1");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.ItemHeight(com_Items.AddItem("Item 2"),48);
excombobox1.Items().AddItem("Item 3");
}
|
|
350
|
How can I remove the filter
public void init()
{
COM com_Column;
anytype var_Column;
;
super();
var_Column = COM::createFromVariant(excombobox1.Columns().Add("Column")); com_Column = var_Column;
com_Column.DisplayFilterButton(true);
com_Column.FilterType(1/*exBlanks*/);
excombobox1.ApplyFilter();
excombobox1.ClearFilter();
}
|
|
349
|
How do I display the icons being selected in the control's label
public void init()
{
COM com_Items;
anytype var_Items;
str var_s;
;
super();
var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql";
var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0";
var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN";
var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=";
excombobox1.Images(COMVariant::createFromStr(var_s));
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.CellImage(com_Items.AddItem("Image 1"),COMVariant::createFromInt(0),1);
com_Items.CellImage(com_Items.AddItem("Image 2"),COMVariant::createFromInt(0),2);
com_Items.CellImage(com_Items.AddItem("Image 3"),COMVariant::createFromInt(0),3);
excombobox1.AssignEditImageOnSelect(0,true);
excombobox1.Value("Image 2");
}
|
|
348
|
How do I select a value
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.IntegralHeight(true);
excombobox1.LinesAtRoot(1/*exGroupLinesAtRoot*/);
excombobox1.TreeColumnIndex(1);
excombobox1.Columns().Add("Column 1");
excombobox1.Columns().Add("Column 2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root 1.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 2.1"),COMVariant::createFromInt(1),"Child 2.2");
com_Items.ExpandItem(h,true);
h = com_Items.AddItem("Root 2.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 2.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
excombobox1.Value("Root 1.1");
}
|
|
347
|
How do I select a value
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.IntegralHeight(true);
excombobox1.LinesAtRoot(1/*exGroupLinesAtRoot*/);
excombobox1.TreeColumnIndex(1);
excombobox1.Columns().Add("Column 1");
excombobox1.Columns().Add("Column 2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root 1.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 2.1"),COMVariant::createFromInt(1),"Child 2.2");
com_Items.ExpandItem(h,true);
h = com_Items.AddItem("Root 2.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 2.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
excombobox1.Select(COMVariant::createFromInt(1),"Root 1.2");
}
|
|
346
|
How do change the visual appearance for the drop down border, using EBN
public void init()
{
;
super();
excombobox1.VisualAppearance().Add(1,"c:\\exontrol\\images\\normal.ebn");
excombobox1.DropDownBorder(16777216);
}
|
|
345
|
How do I remove the drop down's border
public void init()
{
;
super();
excombobox1.DropDownBorder(0/*None2*/);
}
|
|
344
|
How can I change the foreground color for edit controls
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.ForeColorEdit(WinApi::RGB2int(255,0,0));
excombobox1.IntegralHeight(true);
excombobox1.LinesAtRoot(1/*exGroupLinesAtRoot*/);
excombobox1.TreeColumnIndex(1);
excombobox1.Columns().Add("Column 1");
excombobox1.Columns().Add("Column 2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root 1.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 2.1"),COMVariant::createFromInt(1),"Child 2.2");
com_Items.ExpandItem(h,true);
h = com_Items.AddItem("Root 2.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 2.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
excombobox1.Select(COMVariant::createFromInt(0),"Root 1.1");
}
|
|
343
|
How can I change the background color for edit controls
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.BackColorEdit(WinApi::RGB2int(255,0,0));
excombobox1.IntegralHeight(true);
excombobox1.LinesAtRoot(1/*exGroupLinesAtRoot*/);
excombobox1.TreeColumnIndex(1);
excombobox1.Columns().Add("Column 1");
excombobox1.Columns().Add("Column 2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root 1.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 2.1"),COMVariant::createFromInt(1),"Child 2.2");
com_Items.ExpandItem(h,true);
h = com_Items.AddItem("Root 2.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 2.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
excombobox1.Select(COMVariant::createFromInt(0),"Root 1.1");
}
|
|
342
|
How can I hide the drop down buttons when the control loses the focus
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.HideDropDownButton(true);
excombobox1.IntegralHeight(true);
excombobox1.LinesAtRoot(1/*exGroupLinesAtRoot*/);
excombobox1.TreeColumnIndex(1);
excombobox1.Columns().Add("Column 1");
excombobox1.Columns().Add("Column 2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root 1.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 2.1"),COMVariant::createFromInt(1),"Child 2.2");
com_Items.ExpandItem(h,true);
h = com_Items.AddItem("Root 2.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 2.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
}
|
|
341
|
How can I ensure that the drop down portions doesn't show partial items
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.IntegralHeight(true);
excombobox1.LinesAtRoot(1/*exGroupLinesAtRoot*/);
excombobox1.TreeColumnIndex(1);
excombobox1.Columns().Add("Column 1");
excombobox1.Columns().Add("Column 2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root 1.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 2.1"),COMVariant::createFromInt(1),"Child 2.2");
com_Items.ExpandItem(h,true);
h = com_Items.AddItem("Root 2.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 2.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
}
|
|
340
|
How can I close the drop down window when user double clicks it
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.CloseOnDblClk(true);
excombobox1.LinesAtRoot(1/*exGroupLinesAtRoot*/);
excombobox1.TreeColumnIndex(1);
excombobox1.Columns().Add("Column 1");
excombobox1.Columns().Add("Column 2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Root 1.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 2.1"),COMVariant::createFromInt(1),"Child 2.2");
com_Items.ExpandItem(h,true);
h = com_Items.AddItem("Root 2.1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"Root 2.2");
com_Items.CellCaption(com_Items.InsertItem(h,,"Child 1.1"),COMVariant::createFromInt(1),"Child 1.2");
}
|
|
339
|
How do I get the handle of the drop down window
public void init()
{
;
super();
excombobox1.Columns().Add(excombobox1.hWndDropDown());
}
|
|
338
|
How do I specify the height of the control's label
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.LabelHeight(34);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
337
|
The control selects the portion of text that doesn't match with the selected item. How can I avoid that
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.AutoSelect(false);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
336
|
How can I show the drop down window as soon as user starts typing in the control
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.AutoDropDown(true);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
335
|
How do I change the text in the edit or label area
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
excombobox1.EditText(COMVariant::createFromInt(0),"Test");
}
|
|
334
|
How do I lock or make read-only the control
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Locked(true);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
333
|
How do I let user to resize only the height of the drop down window, at runtime
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.AllowSizeGrip(true);
excombobox1.AllowHResize(false);
excombobox1.MinWidthList(100);
excombobox1.MinHeightList(100);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
332
|
How do I let user to resize only the width of the drop down window, at runtime
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.AllowSizeGrip(true);
excombobox1.AllowVResize(false);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
331
|
How do I let user to resize the drop down window, at runtime
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.AllowSizeGrip(true);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
330
|
How do I specify the height of the drop down window
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.HeightList(,400);
excombobox1.MinWidthList(100);
excombobox1.AllowSizeGrip(true);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
329
|
How do I specify the minimum height of the drop down window
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.MinHeightList(100);
excombobox1.AllowSizeGrip(true);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
328
|
How do I specify the width of the drop down window
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.WidthList(,100);
excombobox1.AllowSizeGrip(true);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
327
|
How do I specify the minimum width of the drop down window
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.MinWidthList(100);
excombobox1.AllowSizeGrip(true);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
326
|
I have multiple columns, how can I display a single edit in the control's label
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.SingleEdit(true);
excombobox1.Columns().Add("Column 1");
excombobox1.Columns().Add("Column 2");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.CellCaption(com_Items.AddItem("Item 1"),COMVariant::createFromInt(1),"SubItem 1");
com_Items.CellCaption(com_Items.AddItem("Item 2"),COMVariant::createFromInt(1),"SubItem 2");
com_Items.CellCaption(com_Items.AddItem("Item 3"),COMVariant::createFromInt(1),"SubItem 3");
}
|
|
325
|
How do I turn off the auto complete feature
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.AutoComplete(false);
excombobox1.Columns().Add("Column");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.AddItem("Item 3");
com_Items.AddItem("Item 1");
com_Items.AddItem("Item 2");
}
|
|
324
|
The control supports three styles: Simple, DropDown and DropDownList. How can I change the style
public void init()
{
;
super();
excombobox1.Style(2/*DropDownList*/);
}
|
|
323
|
Is there any option to align the header to the left and the data to the right
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
;
super();
COM::createFromVariant(excombobox1.Columns().Add("Left")).Alignment(0/*LeftAlignment*/);
var_Column = COM::createFromVariant(excombobox1.Columns().Add("Right")); com_Column = var_Column;
com_Column.Alignment(2/*RightAlignment*/);
com_Column.HeaderAlignment(2/*RightAlignment*/);
com_Column.EditAlignment(2/*RightAlignment*/);
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.CellCaption(com_Items.AddItem("left"),COMVariant::createFromInt(1),"right");
}
|
|
322
|
How do I change the control's border, using your EBN files
public void init()
{
;
super();
excombobox1.VisualAppearance().Add(1,"c:\\exontrol\\images\\normal.ebn");
excombobox1.Appearance(16777216);
}
|
|
321
|
Can I change the default border of the tooltip, using your EBN files
public void init()
{
;
super();
excombobox1.ToolTipDelay(1);
excombobox1.ToolTipWidth(364);
excombobox1.VisualAppearance().Add(1,"c:\\exontrol\\images\\normal.ebn");
excombobox1.Background(64/*exToolTipAppearance*/,0x1000000);
COM::createFromVariant(excombobox1.Columns().Add("tootip")).ToolTip("this is a tooltip assigned to a column");
}
|
|
320
|
Can I change the background color for the tooltip
public void init()
{
;
super();
excombobox1.ToolTipDelay(1);
excombobox1.ToolTipWidth(364);
excombobox1.Background(65/*exToolTipBackColor*/,WinApi::RGB2int(255,0,0));
COM::createFromVariant(excombobox1.Columns().Add("tootip")).ToolTip("this is a tooltip assigned to a column");
}
|
|
319
|
Does the tooltip support HTML format
public void init()
{
;
super();
excombobox1.ToolTipDelay(1);
excombobox1.ToolTipWidth(364);
COM::createFromVariant(excombobox1.Columns().Add("tootip")).ToolTip("<font Tahoma;11>T</font>his is an HTML <b>tooltip</b> assigned to a <fgcolor=FF0000>column</fgcolor>");
}
|
|
318
|
Can I change the forecolor for the tooltip
public void init()
{
;
super();
excombobox1.ToolTipDelay(1);
excombobox1.ToolTipWidth(364);
excombobox1.Background(66/*exToolTipForeColor*/,WinApi::RGB2int(255,0,0));
COM::createFromVariant(excombobox1.Columns().Add("tootip")).ToolTip("this is a tooltip assigned to a column");
}
|
|
317
|
Can I change the foreground color for the tooltip
public void init()
{
;
super();
excombobox1.ToolTipDelay(1);
excombobox1.ToolTipWidth(364);
COM::createFromVariant(excombobox1.Columns().Add("tootip")).ToolTip("<fgcolor=FF0000>this is a tooltip assigned to a column</fgcolor>");
}
|
|
316
|
How can I merge cells
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.DrawGridLines(-1/*exAllLines*/);
excombobox1.MarkSearchColumn(false);
excombobox1.Columns().Add("C1");
excombobox1.Columns().Add("C2");
excombobox1.Columns().Add("C3");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("this cell merges the first two columns");
com_Items.CellMerge(h,COMVariant::createFromInt(0),COMVariant::createFromInt(1));
h = com_Items.AddItem();
com_Items.CellCaption(h,COMVariant::createFromInt(1),"this cell merges the last two columns");
com_Items.CellMerge(h,COMVariant::createFromInt(1),COMVariant::createFromInt(2));
h = com_Items.AddItem("this cell merges the all three columns");
com_Items.CellMerge(h,COMVariant::createFromInt(0),COMVariant::createFromInt(1));
com_Items.CellMerge(h,COMVariant::createFromInt(0),COMVariant::createFromInt(2));
h = com_Items.AddItem("this draws a divider item");
com_Items.ItemDivider(h,0);
}
|
|
315
|
How can I merge cells
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.MarkSearchColumn(false);
excombobox1.TreeColumnIndex(-1);
excombobox1.Columns().Add("C1");
excombobox1.Columns().Add("C2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Cell 1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
com_Items.CellSingleLine(h,COMVariant::createFromInt(1),false);
h = com_Items.AddItem("This is bit of text merges all cells in the item");
com_Items.ItemDivider(h,0);
com_Items.CellHAlignment(h,COMVariant::createFromInt(0),1/*CenterAlignment*/);
}
|
|
314
|
How can I change the color for separator / dividers items
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.MarkSearchColumn(false);
excombobox1.TreeColumnIndex(-1);
excombobox1.ScrollBySingleLine(false);
excombobox1.Columns().Add("C1");
excombobox1.Columns().Add("C2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Cell 1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
com_Items.CellSingleLine(h,COMVariant::createFromInt(1),false);
h = com_Items.AddItem();
com_Items.ItemDivider(h,0);
com_Items.ItemDividerLine(h,4/*DoubleDotLine*/);
com_Items.ItemDividerLineAlignment(h,1/*DividerCenter*/);
com_Items.ItemHeight(h,6);
com_Items.SelectableItem(h,false);
h = com_Items.AddItem("Cell 2");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
com_Items.CellSingleLine(h,COMVariant::createFromInt(1),false);
}
|
|
313
|
How can I add separator - dividers items
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.MarkSearchColumn(false);
excombobox1.TreeColumnIndex(-1);
excombobox1.ScrollBySingleLine(false);
excombobox1.Columns().Add("C1");
excombobox1.Columns().Add("C2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Cell 1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
com_Items.CellSingleLine(h,COMVariant::createFromInt(1),false);
h = com_Items.AddItem();
com_Items.ItemDivider(h,0);
com_Items.ItemDividerLine(h,4/*DoubleDotLine*/);
com_Items.ItemDividerLineAlignment(h,1/*DividerCenter*/);
com_Items.ItemHeight(h,6);
com_Items.SelectableItem(h,false);
h = com_Items.AddItem("Cell 2");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
com_Items.CellSingleLine(h,COMVariant::createFromInt(1),false);
}
|
|
312
|
Can I change the style of the line being displayed by a divider item
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.MarkSearchColumn(false);
excombobox1.TreeColumnIndex(-1);
excombobox1.ScrollBySingleLine(false);
excombobox1.Columns().Add("C1");
excombobox1.Columns().Add("C2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Cell 1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
com_Items.CellSingleLine(h,COMVariant::createFromInt(1),false);
h = com_Items.AddItem("This is bit of text that's displayed on the entire item, divider.");
com_Items.ItemDivider(h,0);
com_Items.ItemDividerLine(h,4/*DoubleDotLine*/);
com_Items.CellHAlignment(h,COMVariant::createFromInt(0),1/*CenterAlignment*/);
com_Items.ItemHeight(h,24);
}
|
|
311
|
Can I remove the line being displayed by a divider item
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.MarkSearchColumn(false);
excombobox1.TreeColumnIndex(-1);
excombobox1.Columns().Add("C1");
excombobox1.Columns().Add("C2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Cell 1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
com_Items.CellSingleLine(h,COMVariant::createFromInt(1),false);
h = com_Items.AddItem("This is bit of text that's displayed on the entire item, divider.");
com_Items.ItemDivider(h,0);
com_Items.ItemDividerLine(h,0/*EmptyLine*/);
com_Items.CellHAlignment(h,COMVariant::createFromInt(0),1/*CenterAlignment*/);
}
|
|
310
|
How can I display a divider item, merging all cells
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.MarkSearchColumn(false);
excombobox1.TreeColumnIndex(-1);
excombobox1.Columns().Add("C1");
excombobox1.Columns().Add("C2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Cell 1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
com_Items.CellSingleLine(h,COMVariant::createFromInt(1),false);
h = com_Items.AddItem("This is bit of text that's displayed on the entire item, divider.");
com_Items.ItemDivider(h,0);
com_Items.CellHAlignment(h,COMVariant::createFromInt(0),1/*CenterAlignment*/);
}
|
|
309
|
How can I fix or lock items
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Default");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.LockedItemCount(0/*exTop*/,1);
com_Items.CellCaption(com_Items.LockedItem(0/*exTop*/,0),COMVariant::createFromInt(0),"This is a locked item, fixed to the top side of the control.");
com_Items.ItemBackColor(com_Items.LockedItem(0/*exTop*/,0),WinApi::RGB2int(196,196,186));
com_Items.LockedItemCount(2/*exBottom*/,2);
com_Items.CellCaption(com_Items.LockedItem(2/*exBottom*/,0),COMVariant::createFromInt(0),"This is a locked item, fixed to the top side of the control.");
com_Items.ItemBackColor(com_Items.LockedItem(2/*exBottom*/,0),WinApi::RGB2int(196,196,186));
com_Items.CellCaption(com_Items.LockedItem(2/*exBottom*/,1),COMVariant::createFromInt(0),"This is a locked item, fixed to the top side of the control.");
com_Items.ItemBackColor(com_Items.LockedItem(2/*exBottom*/,1),WinApi::RGB2int(186,186,186));
}
|
|
308
|
How can I fix or lock an item on the bottom side of the control
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.Columns().Add("Default");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.LockedItemCount(2/*exBottom*/,1);
com_Items.CellCaption(com_Items.LockedItem(2/*exBottom*/,0),COMVariant::createFromInt(0),"This is a locked item, fixed to the bottom side of the control.");
h = com_Items.AddItem("Root 1");
com_Items.InsertItem(h,,"Child 1");
com_Items.InsertItem(h,,"Child 2");
com_Items.ExpandItem(h,true);
}
|
|
307
|
How can I fix or lock an item on the top of the control
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.Columns().Add("Default");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.LockedItemCount(0/*exTop*/,1);
com_Items.CellCaption(com_Items.LockedItem(0/*exTop*/,0),COMVariant::createFromInt(0),"This is a locked item, fixed to the top side of the control.");
h = com_Items.AddItem("Root 1");
com_Items.InsertItem(h,,"Child 1");
com_Items.InsertItem(h,,"Child 2");
com_Items.ExpandItem(h,true);
}
|
|
306
|
Is there any function to limit the height of the items when I display it using multiple lines
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
excombobox1.ScrollBySingleLine(true);
excombobox1.Columns().Add("C1");
excombobox1.Columns().Add("C2");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("Cell 1");
com_Items.CellCaption(h,COMVariant::createFromInt(1),"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multiple lines.");
com_Items.CellSingleLine(h,COMVariant::createFromInt(1),false);
com_Items.ItemMaxHeight(h,48);
}
|
|
305
|
Why I cannot center my cells in the column
public void init()
{
;
super();
excombobox1.TreeColumnIndex(-1);
excombobox1.DrawGridLines(-2/*exRowLines*/);
COM::createFromVariant(excombobox1.Columns().Add("Default")).Alignment(1/*CenterAlignment*/);
excombobox1.Items().AddItem("item 1");
excombobox1.Items().AddItem("item 2");
excombobox1.Items().AddItem("item 3");
}
|
|
304
|
How can I align the cell to the left, center or to the right
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.TreeColumnIndex(-1);
excombobox1.DrawGridLines(-2/*exRowLines*/);
excombobox1.Columns().Add("Default");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.CellHAlignment(com_Items.AddItem("left"),COMVariant::createFromInt(0),0/*LeftAlignment*/);
com_Items.CellHAlignment(com_Items.AddItem("center"),COMVariant::createFromInt(0),1/*CenterAlignment*/);
com_Items.CellHAlignment(com_Items.AddItem("right"),COMVariant::createFromInt(0),2/*RightAlignment*/);
}
|
|
303
|
How do I apply HTML format to a cell
public void init()
{
COM com_Items;
anytype var_Items;
int h;
str var_s,var_s1;
;
super();
excombobox1.TreeColumnIndex(-1);
var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql";
var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0";
var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN";
var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=";
excombobox1.Images(COMVariant::createFromStr(var_s));
excombobox1.HTMLPicture("p1","c:\\exontrol\\images\\zipdisk.gif");
excombobox1.HTMLPicture("p2","c:\\exontrol\\images\\auction.gif");
excombobox1.Columns().Add("Default");
var_Items = excombobox1.Items(); com_Items = var_Items;
h = com_Items.AddItem("The following item shows some of the HTML format supported:");
com_Items.CellHAlignment(h,COMVariant::createFromInt(0),1/*CenterAlignment*/);
var_s1 = "<br>text icons <img>1</img>, <img>2</img>, ... pictures <img>p1</img>, <img>p2</img> <br><br>text <b>bold</b>, <i>italic</i>, <u";
var_s1 = var_s1 + ">underline</u>, <s>strikeout</s>, ...<br><dotline>and so on...<br> <a>anchor</a> or <a2>hyperlink</a><br><fgcolor=FF0000>fgcolor";
var_s1 = var_s1 + "</fgcolor> or <bgcolor=00FF00>bgcolor</bgcolor> ";
h = com_Items.AddItem(COMVariant::createFromStr(var_s1));
com_Items.CellCaptionFormat(h,COMVariant::createFromInt(0),1/*exHTML*/);
com_Items.CellSingleLine(h,COMVariant::createFromInt(0),false);
}
|
|
302
|
How can I change the font for a cell
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
excombobox1.Columns().Add("Default");
excombobox1.Items().AddItem("std font");
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.CellCaptionFormat(com_Items.AddItem("this <font tahoma;12>is a bit of text with</font> a different font"),COMVariant::createFromInt(0),1/*exHTML*/);
}
|
|
301
|
How can I change the font for a cell
public void init()
{
COM com_Items,com_f;
anytype f,var_Items;
;
super();
excombobox1.Columns().Add("Default");
excombobox1.Items().AddItem("default font");
f = COM::createFromObject(new stdole.StdFont()); com_f = f;
f.Name("Tahoma");
f.Size(12);
var_Items = excombobox1.Items(); com_Items = var_Items;
com_Items.CellFont(com_Items.AddItem("new font"),COMVariant::createFromInt(0),f);
}
|